home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / CATNOAUD.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  1.6 KB  |  89 lines
  1. rem 
  2. rem $Header: catnoaud.sql 7020100.1 94/09/23 22:14:27 cli Generic<base> $ noaudit.sql 
  3. rem 
  4. Rem Copyright (c) 1990 by Oracle Corporation
  5. Rem NAME
  6. REM    CATNOAUD.SQL
  7. Rem  FUNCTION
  8. Rem    Drop the auditing catalog views, created by audit.sql.
  9. Rem  NOTES
  10. Rem    Must be run while connected to SYS.
  11. Rem  MODIFIED
  12. Rem     glumpkin   10/20/92 -  Renamed from NOAUDIT.SQL 
  13. Rem     rlim       07/30/91 -         added new drop sysnonyms for new auditing
  14. Rem   Chaudhr    03/09/90 - Creation
  15. Rem
  16.  
  17. Rem -- Tables
  18.  
  19. drop table AUDIT_OPTION_MAP
  20. /
  21. drop table AUDIT_ACTIONS
  22. /
  23.  
  24. Rem -- Views
  25.  
  26. drop view  ALL_DEF_AUDIT_OPTS
  27. /
  28. drop view  DBA_OBJ_AUDIT_OPTS
  29. /
  30. drop view  USER_OBJ_AUDIT_OPTS
  31. /
  32. drop view  DBA_STMT_AUDIT_OPTS
  33. /
  34. drop view  DBA_AUDIT_TRAIL
  35. /
  36. drop view  USER_AUDIT_TRAIL
  37. /
  38. drop view  DBA_AUDIT_SESSION
  39. /
  40. drop view  USER_AUDIT_SESSION
  41. /
  42. drop view  DBA_AUDIT_STATEMENT
  43. /
  44. drop view  USER_AUDIT_STATEMENT
  45. /
  46. drop view  DBA_AUDIT_OBJECT
  47. /
  48. drop view  USER_AUDIT_OBJECT
  49. /
  50. drop view  DBA_AUDIT_EXISTS
  51. /
  52.  
  53. Rem -- Public Synonyms [for tables and views]
  54.  
  55. drop public synonym AUDIT_OPTION_MAP
  56. /
  57. drop public synonym AUDIT_ACTIONS
  58. /
  59. drop public synonym ALL_DEF_AUDIT_OPTS
  60. /
  61. drop public synonym USER_TAB_AUDIT_OPTS
  62. /
  63. drop synonym DBA_STMT_AUDIT_OPTS
  64. /
  65. drop synonym DBA_OBJ_AUDIT_OPTS
  66. /
  67. drop synonym DBA_AUDIT_TRAIL
  68. /
  69. drop public synonym USER_AUDIT_TRAIL
  70. /
  71. drop synonym DBA_AUDIT_SESSION
  72. /
  73. drop public synonym USER_AUDIT_SESSION
  74. /
  75. drop synonym DBA_AUDIT_STATEMENT
  76. /
  77. drop public synonym USER_AUDIT_STATEMENT
  78. /
  79. drop synonym DBA_AUDIT_OBJECT
  80. /
  81. drop public synonym USER_AUDIT_OBJECT
  82. /
  83. drop synonym DBA_AUDIT_EXISTS
  84. /
  85.  
  86.  
  87.  
  88.  
  89.